SetArray(Int32,Int32,Object[,]) Method

Sets the values in the specified two-dimensional array of objects into the specified range of cells on this sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetArray( _
   ByVal row As System.Integer, _
   ByVal column As System.Integer, _
   ByVal value(,) As System.Object _
)

'Usage
 
Dim instance As Worksheet
Dim row As System.Integer
Dim column As System.Integer
Dim value() As System.Object
 
instance.SetArray(row, column, value)

public void SetArray( 
   System.int row,
   System.int column,
   System.object[,] value
)

Parameters

row: Row index
column: Column index
value: Array from which to set values

Example

This example uses the SetArray method.

object[,] arr;
gcSpreadSheet1.ActiveSheet.SetArray(1, 0, new String[,] { { "One", "Two" } });
gcSpreadSheet1.ActiveSheet.SetArray(2, 1, new String[,] { { "Three", "Four" } }, false);
arr = gcSpreadSheet1.ActiveSheet.GetArray(1, 0, 3, 2);
gcSpreadSheet1.ActiveSheet.Cells[3, 3].Text = "The value of the first element in the array is " + arr.GetValue(0, 0).ToString();

VB.NET

Dim arr(,) As Object
GcSpreadSheet1.ActiveSheet.SetArray(1, 0, New String(,) {{"One", "Two"}})
GcSpreadSheet1.ActiveSheet.SetArray(2, 1, New String(,) {{"Three", "Four"}}, False)
arr = GcSpreadSheet1.ActiveSheet.GetArray(1, 0, 3, 2)
GcSpreadSheet1.ActiveSheet.Cells(3, 3).Text = "The value of the first element in the array is " & arr.GetValue(0, 0).ToString()

Reference

Worksheet Class
Worksheet Members
Overload List